home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The 640 MEG Shareware Studio 2
/
The 640 Meg Shareware Studio CD-ROM Volume II (Data Express)(1993).ISO
/
business
/
vicardoc.zip
/
VICGLMAI.LST
< prev
next >
Wrap
File List
|
1992-02-29
|
7KB
|
160 lines
@MT6
@HM3
@PN55
@HE VICAR - System Maintenance
17.6 G/L INTERFACE MAINTENANCE -
GENERAL DESCRIPTION -
This module provides some very vital services to the A/R
system and if needed a direct feed to an external G/L system
with the monthly G/L totals. If an external G/L system is not
used or needed, this module will provide very pertinent data
to be used in government reporting, etc. Data such as: Sales
(as a whole, or by individual entity, customer sales type,
Product Sales, etc.), Sales Tax (as a whole, entity, etc.),
etc. The amount of detail is dependent on how the G/L system
is set up, either initially or in the future, as long as the
user has some background in general accounting and has spent
some time determining how much of a breakdown will be needed
when the G/L system is set up.
NOTE - If you do NOT have somewhat of an understanding of
general accounting, I suggest you pick up a book or two from
the library on Business (Financial) Accounting. You should at
least become familiar with the Double-Entry method of
accounting and its purpose. Like anything regarding business,
it is better to analyze something a little before proceeding
than to proceed without any thought at all and have to redo it
all over again and pay the consequences of time and money.
Listed below is a basic G/L breakdown that can be used:
Acct. # Type Descr.
1000.000 A Cash
1200.000 A A/R
2400.000 I Sales Tax
3301.000 I Sales
3305.000 I Misc. Sales
3306.000 I Freight
3690.000 E Discounts Allowed
4300.000 I Finance Charges Assessed
17.6.1 ADD G/L NUMBER - is used to add G/L numbers to the G/L
system. It is Vital that the TYPE given to each G/L number is
correct otherwise the reporting totals will not balance as
required by the Double-Entry accounting method. The fields
as shown in Figure 17.6.1 are as follows:
G/L Number - This number must be unique. The G/L number
is made up of 2 parts as follows: NNNN.ddd
NNNN - a Specific G/L number.
ddd - the department within this G/L number. **
** a department number is NOT needed unless the user
requires a G/L number to be broken up into departments.
@PA
General Description - Continued.
NOTE - Pressing the <F4> key while in this field will bring up
the G/L Selection window. A selection cannot be made in ADD
because it is only for reference purposes.
*** Only Available in the Registered Version.
G/L Description - A general description of this G/L
account. Used in reporting and selection menu above.
G/L Type - This is a Pertinent field that must contain
the correct type for a specific Account. Valid types are:
A - Assets (such as: Cash Acct, A/R)
E - Expense (Discounts given)
I - Income (Sales, Sales Tax, Mail Charges, etc.)
L - Liabilities (A/P, etc.)
R - Retained Earnings
Acct. MTD $ - Account Balance for this month. ***
Acct. YTD $ - Account Balance for this Year so far. ***
*** The above amounts should not be manipulated unless
you know what you are doing.
17.6.2 Search G/L Number - Used to search through the G/L
accounts and do any minor maintenance that might be needed
such as changing an account Name, Type, etc. Only for those
who know what they are doing. Normally, nothing will need to
be changed directly if everything is set up right in the first
place.
NOTE - If a G/L number is Deleted, make sure to Replace/Change
it in any of the affected customers Master Files before
posting transactions, etc. POSTING Errors will occure
otherwise.
17.6.3 List G/L Numbers on File - This allows the user to print
or view a simple report showing the Account numbers on File
and their respective descriptions and Types.
17.6.4 Print G/L Report - This allows the user to print or view
a report of the Account Balances of ALL accounts on file. The
Credit & Debit Balances of this report should Balance.
17.6.5 Export G/L Totals - This module will allow the user to
export the Month-To-Date totals for each account out to a Text
Delimited file that can be read directly by AccPac Plus G/L
6.0. This file could also be read by other G/L files that you
can specify the Import File format.
@PA
Export G/L Totals - Continued.
NOTE - If you are a registered user, you can obtain a modified
version of Vicar that will write the Export file in a format
that is compatible with your G/L system for a minimal fee.
Just send a copy of your G/L documentation specifying the
Import File format with your Registration fee or Registration
Number (for Registered users). If major modifications are
needed, I will send you a written quote indicating such.
The Export G/L totals Entry screen contains the following Fields:
Default Export Filename - The filename to create in
Writing the G/L Export data.
G/L Fiscal Period - The fiscal period of the data
to be exported. This field is needed by AccPac G/L.
Other G/L systems might require different or additional
data beyond this field.
NOTE - Once the export function is completed, the program
will automatically go into the Clear Month-To-Date Totals
procedure. In this way the user can make it a habbit to use
the Export function instead of the Clear Month-To-Date
function and thereby avoid loosing data by performing these 2
steps in an incorrect order.
17.6.6 MTD Clear Totals - This process Clears the G/L totals for
the month. Make sure ALL reports are generated/printed before
clearing totals. If Totals are to be Exported then use the
Export Totals Module above which will then run this process
once the Totals have been successfully Exported. The
following Prompt will be displayed before proceeding with the
Clear MTD Totals process:
"*** CLEAR - MTD Customer Totals ***"
"Do you want to Clear the MONTH TO DATE Totals (Y/N): "
17.6.7 YTD Clear Totals - The same as above but also clears the
Year To Date Totals. This procedure must be run After the
Export Totals module is run. The Export Totals Module will
ONLY "invoke" the clear MTD totals process. You can just
answer "No" to the Clear MTD Totals prompt after the Export
Totals routine is run and just select this process instead.
It will clear BOTH MTD & YTD totals simultaneously. The
following prompt will be displayed before proceeding with the
Clear YTD Totals process:
"*** CLEAR - YTD Customer Totals ***"
"Do you want to Clear the YEAR TO DATE Totals (Y/N): "